DROP TABLE login
CREATE TABLE login (
	aid INT IDENTITY(100001,1) PRIMARY KEY UNIQUE NOT NULL,
	accountname VARCHAR(45) UNIQUE NOT NULL,
	password VARCHAR(65) NOT NULL,
	grade TINYINT NOT NULL DEFAULT 0,
	isConfirmed TINYINT NOT NULL DEFAULT 0,
	lastServer TINYINT NOT NULL DEFAULT 0,
	lastIP VARCHAR(20),
	ipForce VARCHAR(20),
	regDate DATETIME NOT NULL DEFAULT GetDate(),
	expireDate DATETIME,
	lastconnectDate DATETIME,
	blockEndDate DATETIME
)
CREATE INDEX idx_login_accountname ON login(accountname)